﻿CREATE TABLE [dbo].[Projekt] (
    [ProjektKey]     INT            IDENTITY (1, 1) NOT NULL,
    [Änderung]       DATETIME       NULL,
    [ProjektNummer]  NVARCHAR (30)  COLLATE Latin1_General_CI_AS NULL,
    [Adresse]        NVARCHAR (70)  COLLATE Latin1_General_CI_AS NULL,
    [EPLZ]           INT            DEFAULT ((0)) NULL,
    [Straße]         NVARCHAR (50)  COLLATE Latin1_General_CI_AS NULL,
    [Verkäufer]      INT            DEFAULT ((0)) NULL,
    [Potential]      NVARCHAR (250) COLLATE Latin1_General_CI_AS NULL,
    [Beschreibung]   NVARCHAR (250) COLLATE Latin1_General_CI_AS NULL,
    [Status]         INT            DEFAULT ((0)) NULL,
    [Ausschreibung]  DATETIME       NULL,
    [Vergabe]        DATETIME       NULL,
    [Fertigstellung] DATETIME       NULL,
    [Erhalten]       BIT            DEFAULT ((0)) NULL,
    [Notiz]          NTEXT          COLLATE Latin1_General_CI_AS NULL,
    CONSTRAINT [PK_Projekt] PRIMARY KEY CLUSTERED ([ProjektKey] ASC)
);

